﻿1. Open the Package Manager Console.

2. Select "DataAccess" as the Default Project and on top, select WebAPI as the startup project.

3. Run the following command in the Package Manager console:

PM> Add-Migration InitialCreate

This will create the classes for supporting migrations.

4. Close all opened files.

/-----------------------------------------------------/

5. Add GetAccountEquity stored procedure:

Copy and paste the code inside SP_GetAccountEquity "Up" method to the bottom of the "Up" method of the migration file created <date>_InitialCreate.cs

6. Now let’s apply all the changes to the server.

Run the following command:

PM> Update-Database
